[dbo].[BAECartGetCartUsers]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartGetCartUsers

Properties
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

create procedure [dbo].[BAECartGetCartUsers] as
SELECT DISTINCT ci.UserID, n.LAST_NAME + ', ' + n.FIRST_NAME AS 'FullName'
    FROM CartItem AS ci
    LEFT JOIN Name AS n on n.ID COLLATE database_default = ci.UserID COLLATE database_default
    ORDER BY ci.UserID desc

GO

Uses

[dbo].[CartItem]
[dbo].[Name]
dbo